prepare("SELECT * FROM students WHERE id = ?"); $stmt->execute([$_SESSION['student_id']]); $student = $stmt->fetch(PDO::FETCH_ASSOC); // Get available exams with multiple subjects $stmt = $pdo->prepare(" SELECT e.*, COUNT(DISTINCT es.subject_id) as subject_count, GROUP_CONCAT(DISTINCT s.name SEPARATOR ', ') as subject_names FROM exams e LEFT JOIN exam_subjects es ON e.id = es.exam_id LEFT JOIN subjects s ON es.subject_id = s.id WHERE e.status = 'active' GROUP BY e.id ORDER BY e.year DESC, e.name "); $stmt->execute(); $exams = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get recent results $stmt = $pdo->prepare(" SELECT r.*, e.name as exam_name, e.year, e.min_subjects, e.max_subjects FROM results r JOIN exam_sessions es ON r.session_id = es.id JOIN exams e ON es.exam_id = e.id WHERE es.student_id = ? ORDER BY r.submitted_at DESC LIMIT 5 "); $stmt->execute([$_SESSION['student_id']]); $recent_results = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> Student Dashboard - MMGSS NNEWI CBT

Welcome back, ! 👋

Registration Number:

Ready to ace your next exam? Choose from the available tests below.

📚 Available Exams

0): ?>

Available Subjects:
📋 Subject Selection

You can choose to subjects for this exam

⏱️ minutes
📖 subjects
🎯 Choose -
📝 Multiple choice
Select Subjects & Start Exam 🚀

No exams available

There are no active exams at the moment. Please check back later.

📊 Recent Results

0): ?>
= 80) { $performance_class = 'performance-excellent'; $performance_text = 'Excellent'; } elseif ($percentage >= 60) { $performance_class = 'performance-good'; $performance_text = 'Good'; } elseif ($percentage >= 40) { $performance_class = 'performance-average'; $performance_text = 'Average'; } else { $performance_class = 'performance-poor'; $performance_text = 'Needs Improvement'; } ?>
()
/

Percentage: %

Subjects Taken: of

No results yet

Complete your first exam to see your results here!